All Questions
Tagged with djangodatabase-design
16 questions
-3votes
1answer
92views
Creating a Django web-app with Sage 200 Database
I have been asked to create a Django/Python web app that creates web-based, .pdf and excel reports from a Sage Evolution database. While the sage front-end is still being used. My client essentially ...
- 101
0votes
3answers
248views
Fetch the most recently updated records in a database across multiple tables in a performant manner
I have an Angular + Django web application in which Django functions as my backend. In this web application, I have 12 different tables about articles, each table representing a different kind of ...
-2votes
1answer
239views
Use 1 to many relationship on same model or split it into two different models?
I'm building a forum application using the Django web framework but I'm not sure how to design the entity relationship diagram when it comes to the Post model. Since one Post can have many replies, ...
3votes
2answers
1kviews
How should I structure my database entities with invites and recipients for e-signing web app?
I am interested in implementing the following requirements for my e-signature web application. A user can create a new signing contract. That contract can include multiple users to sign. The contract ...
0votes
2answers
191views
How should I update non-maintained database tables between production and development?
I'm working on a Django web application (with a mySQL back-end) that uses non-maintained tables(tables not modified by the web app). However, I have two copies of the data tables (one for production ...
- 23
1vote
1answer
154views
Bulk Inserting Data with Duplicates or Line by Line Insertion Without
I am loading a large amount of data (2,000 files with about 30,000 rows, 30 columns) for use in a Django application. The files are based on 40 different templates. The column names are consistent ...
- 115
0votes
1answer
545views
Looking for advice on how to implement Likes
I'm using Django and Django-Rest-Framework to build a simple photo sharing app/website and just now getting around to implementing a "Like" system. A couple of options I've thought about (surely there ...
- 319
-1votes
1answer
110views
How should I handle an object that has copies of another object?
I really hope this is a good place to ask this since the answers might be subjective, but here it my problem: This is probably irrelevant, but I'm working with Python and Django here. I have the ...
0votes
2answers
68views
Filtering Deleted Objects
Picture a simple messaging app written in Django. Users have the option to delete messages at any time, but the messages need to be retained in the database. There are two options: A deleted attribute ...
3votes
1answer
245views
Django database modelling
I'm starting a project with Django, previously I've used Yii and Rails and they have tools that will take a DB structure and build models for you based off the DB structure. From what I've read Django ...
- 173
1vote
0answers
915views
the right way to generate my Django model/db_table
I went through the Django tutorial with in mind to go through it again using it to set up my small app. So now I am making a simple app where users can search a large set of strings and get a subset ...
- 433
3votes
1answer
891views
Is it good practise to have the class name as a prefix in Django model?
I wrote a model in this format in Django: class Block(models.Model): block_id = models.AutoField(primary_key=True) block_name = models.CharField(max_length=200) block_code = models....
- 571
5votes
1answer
6kviews
Database design/relationship for threading messages
What's the database design or business logic for creating an app for messaging between users? I am having difficulties with choosing how to approach the relationship between each Conversation of User ...
1vote
1answer
871views
Best practices when dealing with lots of empty table columns?
I have a schema that allows for multiple post types in my Django project (kinda like Tumblr). Users can make Posts of different types. One of those types is a photo, which I'll want the EXIF data for. ...
- 255
2votes
2answers
1kviews
Should model / table names be as generic as possible?
When naming a model, should the name be as generic as possible-- even if that won't be the name displayed to users? For example let's imagine a Django model for liking another user's posts. Does it ...
- 255
